﻿<%@ Page Title="Departure Flt. Report" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="DepFltReport.aspx.cs" Inherits="IFD2.DepFltReport" %>
<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">
    <form id="form1" runat="server" role="form" class="form-inline" defaultbutton="lbtnQuery">
    <%--<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
    <asp:UpdatePanel ID="UpdatePanel1" runat="server"><ContentTemplate>--%>
    <div class="container-fluid body-content" style="width:100%;">

    <div class="row">
        <div class="col-sm-2 well well-sm">
            <h5><asp:Literal ID="litTitle" runat="server" meta:resourcekey="tipPageTitle"></asp:Literal></h5>
            <div class="form-group">
                <asp:Label ID="Label1" runat="server" Text="Flight:" meta:resourcekey="Flight"></asp:Label>
                <asp:Label ID="lblAirline" runat="server"></asp:Label>
                <asp:TextBox ID="txtFltNo" runat="server" CssClass="form-control input-sm" Width="100%"></asp:TextBox>
                <asp:Label ID="Label2" runat="server" Text="Date:" meta:resourcekey="Date"></asp:Label>
                <asp:TextBox ID="txtFltDate" runat="server" CssClass="form-control input-sm" Width="100%"></asp:TextBox>
            </div>
            <br class="hidden-xs"/><br class="hidden-xs"/>
            <asp:LinkButton ID="lbtnQuery" runat="server" CssClass="form-control input-sm btn-primary text-center" Width="100%" ToolTip="" meta:resourcekey="tipQuery" OnClick="lbtnQuery_Click"> <span class="glyphicon glyphicon-search" style="font-size:large;"></span></asp:LinkButton>
            <p></p><%--没有此行(或&nbsp;)，上面的按钮在手机模式(xs)下，只有上半部可以点击！--%>
            <asp:Label ID="lblError" runat="server" CssClass="ifdMessage"></asp:Label>
        </div>

        <div class="col-sm-10 well well-sm">
            <div class="panel">
                <div class="panel-heading btn-primary">
                    <h6 class="panel-title" id="section-2"><asp:Literal ID="Literal1" runat="server" meta:resourcekey="tipPageTitle"></asp:Literal></h6>
                </div>
                <div class="panel-body">
                    <asp:Label ID="lblNote" runat="server"  meta:resourcekey="Note">Note:</asp:Label>
                    <div class="table-responsive">
                        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None" style="min-width:2800px;width:100%;" class="table-hover">
                            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                            <RowStyle BackColor="#EFF3FB" />
                            <Columns>
                                <asp:BoundField DataField="airline" HeaderText="airline" SortExpression="airline"  meta:resourcekey="airline" />
                                <asp:BoundField DataField="flt_no" HeaderText="flt_no" SortExpression="flt_no"  meta:resourcekey="flt_no" />
                                <asp:BoundField DataField="flt_date" HeaderText="flt_date" SortExpression="flt_date"  meta:resourcekey="flt_date" />
                                <asp:BoundField DataField="ori_airport" HeaderText="ori_airport" SortExpression="ori_airport"  meta:resourcekey="ori_airport" />
                                <asp:BoundField DataField="des_airport" HeaderText="des_airport" SortExpression="des_airport"  meta:resourcekey="des_airport" />
                                <asp:BoundField DataField="bk_id" HeaderText="bk_id" SortExpression="bk_id"  meta:resourcekey="bk_id" />
                                <asp:BoundField DataField="pax_sn" HeaderText="pax_sn" SortExpression="pax_sn"  meta:resourcekey="pax_sn" />
                                <asp:BoundField DataField="trip_sn" HeaderText="trip_sn" SortExpression="trip_sn"  meta:resourcekey="trip_sn" />
                                <asp:BoundField DataField="family_name" HeaderText="family_name" SortExpression="family_name"  meta:resourcekey="family_name" />
                                <asp:BoundField DataField="name" HeaderText="name" SortExpression="name"  meta:resourcekey="name" />
                                <asp:BoundField DataField="age_type" HeaderText="age_type" SortExpression="age_type"  meta:resourcekey="age_type" />
                                <asp:BoundField DataField="cabin" HeaderText="cabin" SortExpression="cabin"  meta:resourcekey="cabin" />
                                <asp:BoundField DataField="class" HeaderText="class" SortExpression="class"  meta:resourcekey="class" />
                                <asp:BoundField DataField="seat_status" HeaderText="seat_status" SortExpression="seat_status"  meta:resourcekey="seat_status" />
                                <asp:BoundField DataField="dcs_status" HeaderText="dcs_status" SortExpression="dcs_status"  meta:resourcekey="dcs_status" />
                                <asp:BoundField DataField="seat_cabin" HeaderText="seat_cabin" SortExpression="seat_cabin"  meta:resourcekey="seat_cabin" />
                                <asp:BoundField DataField="fare_code" HeaderText="fare_code" SortExpression="fare_code"  meta:resourcekey="fare_code" />
                                <asp:BoundField DataField="fare_cabin" HeaderText="fare_cabin" SortExpression="fare_cabin"  meta:resourcekey="fare_cabin" />
                                <asp:BoundField DataField="fare_class" HeaderText="fare_class" SortExpression="fare_class"  meta:resourcekey="fare_class" />
                                <asp:BoundField DataField="fare_currency" HeaderText="fare_currency" SortExpression="fare_currency"  meta:resourcekey="fare_currency" />
                                <asp:BoundField DataField="final_price" HeaderText="final_price" SortExpression="final_price"  meta:resourcekey="final_price" />
                                <asp:BoundField DataField="final_surcharges" HeaderText="final_surcharges" SortExpression="final_surcharges"  meta:resourcekey="final_surcharges" />
                                <asp:BoundField DataField="pay_currency" HeaderText="pay_currency" SortExpression="pay_currency"  meta:resourcekey="pay_currency" />
                                <asp:BoundField DataField="fare_roe" HeaderText="fare_roe" SortExpression="fare_roe"  meta:resourcekey="fare_roe" />
                            </Columns>
                            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                            <EditRowStyle BackColor="#2461BF" />
                            <AlternatingRowStyle BackColor="White" />
                        </asp:GridView>

                        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:IFD_DB %>"
                            SelectCommand="bll_flt_get_final_pax_list" SelectCommandType="StoredProcedure" DataSourceMode="DataReader">
                            <SelectParameters>
                                <asp:SessionParameter Name="airline" SessionField="AIRLINE" Type="String" />
                                <asp:ControlParameter ControlID="txtFltNo" Name="flt_no" PropertyName="Text" Type="String" />
                                <asp:ControlParameter ControlID="txtFltDate" Name="flt_date" PropertyName="Text" Type="DateTime" />
                            </SelectParameters>
                        </asp:SqlDataSource>
                    </div>
                    
                </div>
            </div>
        </div>
    </div>

    </div>
    <%--</ContentTemplate></asp:UpdatePanel>--%>
    </form>

    <script src="JS/ScrollableGridPlugin.min.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            var win_height = parseInt($(window).height());
            var tab_new_height= win_height-50-100;//菜单占50， 为便于操作留空100
            if ($('#<%=GridView1.ClientID %>').height()>tab_new_height)
                $('#<%=GridView1.ClientID %>').Scrollable({ ScrollHeight: tab_new_height });
        });
    </script>

</asp:Content>
